﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_Linkman_DelLinkmanFromList]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_Linkman_DelLinkmanFromList];
GO
CREATE PROCEDURE [dbo].[sproc_Linkman_DelLinkmanFromList]
@type        int,
@linkmanid    int
/*-----------------------------------------------
功能：    从联系人列表中把此联系人删除
参数：
    @type        int    :    联系人的类型
    @linkmanid    int    :    联系人id

------------------------------------------------*/
AS
    DELETE FROM UDS_Linkman_LinkmanList
    WHERE LinkmanType=@type    AND LinkmanID=@linkmanid